UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SconNNKDFzzEt2YZWamLT8rKaUAbxNg7H935glnGIqU='
WHERE
key_id = '9b4514366d4d0930d27a3a81b4564b8803b21464f35c7a979f237e073f5cfb4b'
AND (
token = 'SconNNKDFzzEt2YZWamLT8rKaUAbxNg7H935glnGIqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)