UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Y+MAl5U47lfE78n4qMGfgD0fomUAs6BayIWt2VMgy0='
WHERE
key_id = 'b9dd3a1592c6540f6bd798e1e238aae3b16820f4898441a205506b0c1485da26'
AND (
token = '6Y+MAl5U47lfE78n4qMGfgD0fomUAs6BayIWt2VMgy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)