UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mjfBPg1htZxIX2byvGko+uLMoFEy9Tg3G8j/Ayp3o9A='
WHERE
key_id = 'b76c5dc699a7ddf933ed2e8c5c5e7cdfbd1ab5563c917b5ee9c72eb54c427bbf'
AND (
token = 'mjfBPg1htZxIX2byvGko+uLMoFEy9Tg3G8j/Ayp3o9A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)