UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1JkmGOY1lb4F6E7hCoOG0hxJ5yA2YccYupuINf7pDQM='
WHERE
key_id = 'b09a119586ea60ad687b7d1cbc39b0acb43726091dee7c6d4a1584d39da891ef'
AND (
token = '1JkmGOY1lb4F6E7hCoOG0hxJ5yA2YccYupuINf7pDQM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)