UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rpA6s0RUboy2kOlnkBp8IXVPsT0ki+6+1WysbnmP3M8='
WHERE
key_id = 'c8226b5c6be4c336785427ce78940828387105da5e9105438cd9f6257ae7e547'
AND (
token = 'rpA6s0RUboy2kOlnkBp8IXVPsT0ki+6+1WysbnmP3M8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)