UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qTgmaaZhY66z597WZGqaqiEvwSVwtEuzGbekRJRoX+0='
WHERE
key_id = '5294040cd5a0139a4b8f9c0e54d697a786ef7def2ed6b2816181868c598635a6'
AND (
token = 'qTgmaaZhY66z597WZGqaqiEvwSVwtEuzGbekRJRoX+0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)