UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YxUd1dSs+ULO8JcQhNGIRV/nMCDNh0aLlA+o2xOifRY='
WHERE
key_id = '6b7ebd18a40c87799c8f2b84920484e6952a9fe211099fcafe44b818e79cf865'
AND (
token = 'YxUd1dSs+ULO8JcQhNGIRV/nMCDNh0aLlA+o2xOifRY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)