UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SGBYFzdcWgZwtdk1HMPeIGWSLLsvUWsUy/cp4TAOjxU='
WHERE
key_id = 'f8ed699b01d14600a49e2700bdb9d31cd67d545d80148ba051b0e38fc12c5bb9'
AND (
token = 'SGBYFzdcWgZwtdk1HMPeIGWSLLsvUWsUy/cp4TAOjxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)