UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3oxKoc2kZyk6wI9G4SP1KEzfhaKe5RhM4TOtDyja2zk='
WHERE
key_id = '2ccb9b6e2ebad1bcd69ab373c3141a548a05b6c97f830478048e52f14fa59d46'
AND (
token = '3oxKoc2kZyk6wI9G4SP1KEzfhaKe5RhM4TOtDyja2zk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)