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