UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZ63aYlHoZgACt9tpcpFgC+XroZrty56tqSe7N9FByU='
WHERE
key_id = 'd6eb2bdd7815d58ffe689ac972f3c2c1d6a53797396a779850425a85ba328b7f'
AND (
token = 'XZ63aYlHoZgACt9tpcpFgC+XroZrty56tqSe7N9FByU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)