UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UD2zXEVmeyPGCCVudmbHlrNJwIHUwNZY3YhCKEIodOo='
WHERE
key_id = '8cfd099d2e787790f196b655d5aaa57c870def4051f018a0a32403e1e3dc6987'
AND (
token = 'UD2zXEVmeyPGCCVudmbHlrNJwIHUwNZY3YhCKEIodOo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)