UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SW8InShaYPtgTOs3IcnwiSRWJcKMYFwxlhfoJJZsnDU='
WHERE
key_id = 'c79e0b62dcc70658572c6535f76d948a0d0ad19032ee70e9ea36da3bdbad4fe9'
AND (
token = 'SW8InShaYPtgTOs3IcnwiSRWJcKMYFwxlhfoJJZsnDU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)