UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8W7Cc1sIqUVMQEO3TFjmcw7kTQT5cgzPvn6xiDezNuw='
WHERE
key_id = 'ac389f4fc203cadb6a5b7219c57d711abc715c093979f6f539088e8f1e5772f3'
AND (
token = '8W7Cc1sIqUVMQEO3TFjmcw7kTQT5cgzPvn6xiDezNuw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)