UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RUhSYAo0gV4fPNyL04Ae3pHN2jWvszIYKBkYE44muHM='
WHERE
key_id = '73e3dcf1b639d08209c74e8d144e94978391b955a290ee89858456c3e11c142a'
AND (
token = 'RUhSYAo0gV4fPNyL04Ae3pHN2jWvszIYKBkYE44muHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)