UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0qM0pqoje++BzW3qWS36ksNF4Fh5lRUEEBCC1iopBQo='
WHERE
key_id = 'ca94e67d761e8ef2fdfac62db7e17d196bbc2d0502ea11766bd2ddede18114bd'
AND (
token = '0qM0pqoje++BzW3qWS36ksNF4Fh5lRUEEBCC1iopBQo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)