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