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