UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tHaACEShF+JXAZfV3oCip7Qd+/IYBvzEUw9VQjZ14QA='
WHERE
key_id = 'a5461881e10f1ce22c51be29cac712f3b93a48a218998f846c2be14399efad3a'
AND (
token = 'tHaACEShF+JXAZfV3oCip7Qd+/IYBvzEUw9VQjZ14QA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)