UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NXonl6tEaVxqA0EIL4W3sOYtDikOg/NDThI8DGJv9i0='
WHERE
key_id = '2ea3867a0585a8c42cdfd44d39e3b3ee7eb5ae686e3e1420a5cccfa1a71e333a'
AND (
token = 'NXonl6tEaVxqA0EIL4W3sOYtDikOg/NDThI8DGJv9i0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)