UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HVlIQyV23/W35gAbxJWHSsqy1nFFzVJ4KP1E9FIyaAc='
WHERE
key_id = '9ecdb872b51692dcc00801b57b883c3db77efccf9b4b341c12fb72b5477c5458'
AND (
token = 'HVlIQyV23/W35gAbxJWHSsqy1nFFzVJ4KP1E9FIyaAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)