UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BJgFXIn0W5W+VhLY0EdKtZDYVZ7XsmVolpaOCVVG9Ko='
WHERE
key_id = '4a6a7b4e10cc8b057df95b3a363785b77b548716742720c3d09363bc60f18b9b'
AND (
token = 'BJgFXIn0W5W+VhLY0EdKtZDYVZ7XsmVolpaOCVVG9Ko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)