UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hObBKAb1Z4hxR4dRRNisJM8KLiytxmyKIWLsEwdcey8='
WHERE
key_id = '7d3e01b93163556abcf3aa31afb2634f5c1410437dd0e7cc51375b1838256ae1'
AND (
token = 'hObBKAb1Z4hxR4dRRNisJM8KLiytxmyKIWLsEwdcey8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)