UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CpLT8m23Lpnw+MRbVSxg90s00whN3VThc1/LmEE7bJw='
WHERE
key_id = '56e9ed01e69f4a82082a7681ebbbf5ae7831453615414559b7ad1e85b2f3f503'
AND (
token = 'CpLT8m23Lpnw+MRbVSxg90s00whN3VThc1/LmEE7bJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)