UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Mg78xOtKG0xZX2NIfvA4FGFnVIYS8OvCT7/xMT8/nIU='
WHERE
key_id = '2763ffb36167314a75d279c951c252bea5590aad0fa0efaee86f5d09788ff7ff'
AND (
token = 'Mg78xOtKG0xZX2NIfvA4FGFnVIYS8OvCT7/xMT8/nIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)