UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '56xjHMGcd6HCF5iIKoq7cgBPzcK+J5fpFeU+IB0kYoU='
WHERE
key_id = 'c7e89977176dd88b123b562965dffb1835191cb9fb40b0689a7622fea342059c'
AND (
token = '56xjHMGcd6HCF5iIKoq7cgBPzcK+J5fpFeU+IB0kYoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)