UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q7jPZzmcNL/Vq923iF4BL7kujIZuMEBzzJxnZo43lKA='
WHERE
key_id = '8f27884a6fde384041ab33049fadb83f6df21a650db84fe1e3dea8e8e6f42ebe'
AND (
token = 'Q7jPZzmcNL/Vq923iF4BL7kujIZuMEBzzJxnZo43lKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)