UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bHH5n4+5hN5kmgXmHthyq8CaStETLSou8nAHy9+NY1M='
WHERE
key_id = 'b258b7f2a534d7a5677374721d3afe665d1f3674e05480d6589c6710a32cee35'
AND (
token = 'bHH5n4+5hN5kmgXmHthyq8CaStETLSou8nAHy9+NY1M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)