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