UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KAHscNAdVUCNZjAqjyKZzifOi9q62WQAVWr0uq/vIgY='
WHERE
key_id = '1ad8dc54fc6e546d1d224fc4ce7645ed7e3de50c08c24db402e897c46581a2a8'
AND (
token = 'KAHscNAdVUCNZjAqjyKZzifOi9q62WQAVWr0uq/vIgY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)