UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RKCLfg5NIm3ynczgpAvJv45WvCQP1ofA/uWXJIXALXk='
WHERE
key_id = 'e24f4fd03709dff6c37a4c173c6a9e881b375b2f231fdf44a56ca44c9acb9f5a'
AND (
token = 'RKCLfg5NIm3ynczgpAvJv45WvCQP1ofA/uWXJIXALXk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)