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