UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lTFc8U3iZY2NBPXsMjtAoLRLDS6zcsOxyKdee9QcksA='
WHERE
key_id = 'a82a0b76ac63840a491afd7a529f014e85c69593e87515a58a0536a547c9058c'
AND (
token = 'lTFc8U3iZY2NBPXsMjtAoLRLDS6zcsOxyKdee9QcksA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)