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